

namespace ERP_RORZE_ORDER.Common
{

public class OrderConstants
{
	#region Prefix
	public const string Prefix = "ERP_RORZE_ORDER";
	#endregion

	#region Entities
	public class Entities
	{
		#region Currency
		public class Currency
		{
			public const string Name = "Currency";
			public class FieldName 
			{
				public const string ID="ID";
				public const string CurrencyID="CurrencyID";
				public const string CurrencyName="CurrencyName";
			}
		}
		#endregion

		#region Kind
		public class Kind
		{
			public const string Name = "Kind";
			public class FieldName
			{
				public const string ID="ID";
				public const string KindID="KindID";
				public const string KindName="KindName";
			}
		}
		#endregion

		#region Maker
		public class Maker
		{
			public const string Name = "Maker";
			public class FieldName
			{
				public const string ID="ID";
				public const string MakerID="MakerID";
				public const string EnglishName="EnglishName";
				public const string JapanName="JapanName";
			}
		}
		#endregion

		#region Order
		public class Order
		{
			public const string Name = "Order";
			public class FieldName
			{
				public const string ID="ID";
				public const string OrderID="OrderID";
				public const string Date="Date";
				public const string StaffID="StaffID";
				public const string Approved="Approved";
			}
		}
		#endregion

		#region OrderDelivery
		public class OrderDelivery
		{
			public const string Name = "OrderDelivery";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string OrderID="OrderID";
				public const string ProductID="ProductID";
				public const string Deadline="Deadline";
				public const string Quantity="Quantity";
				public const string Status="Status";
			}
		}
		#endregion

		#region OrderInput
		public class OrderInput
		{
			public const string Name = "OrderInput";
			public class FieldName
			{
				public const string ID="ID";
				public const string OrderID="OrderID";
				public const string ProductID="ProductID";
				public const string Deadline="Deadline";
				public const string Quantity="Quantity";
				public const string ExchangeRate="ExchangeRate";
				public const string PurchaseID="PurchaseID";
				public const string PGroupID="PGroupID";
				public const string Status="Status";
				public const string Note="Note";
			}
		}
		#endregion

		#region PGroup
		public class PGroup
		{
			public const string Name = "PGroup";
			public class FieldName
			{
				public const string ID="ID";
				public const string PGroupID="PGroupID";
				public const string PGroupName="PGroupName";
			}
		}
		#endregion

		#region Product
		public class Product
		{
			public const string Name = "Product";
			public class FieldName
			{
				public const string ID="ID";
				public const string ProductID="ProductID";
				public const string ProductName="ProductName";
				public const string EnglishName="EnglishName";
				public const string VietName="VietName";
				public const string JapanName="JapanName";
				public const string Size="Size";
				public const string MakerID="MakerID";
				public const string ProductGroupID="ProductGroupID";
				public const string SupplierID="SupplierID";
				public const string KindID="KindID";
				public const string UnitID="UnitID";
				public const string Price="Price";
				public const string CurrencyID="CurrencyID";
				public const string PurposeID="PurposeID";
			}
		}
		#endregion

		#region ProductGroup
		public class ProductGroup
		{
			public const string Name = "ProductGroup";
			public class FieldName
			{
				public const string ID="ID";
				public const string GroupID="GroupID";
				public const string GroupName="GroupName";
				public const string Note="Note";
			}
		}
		#endregion

		#region Purchaser
		public class Purchaser
		{
			public const string Name = "Purchaser";
			public class FieldName
			{
				public const string ID="ID";
				public const string PurchaseID="PurchaseID";
				public const string PurchaseName="PurchaseName";
			}
		}
		#endregion

		#region Purpose
		public class Purpose
		{
			public const string Name = "Purpose";
			public class FieldName
			{
				public const string ID="ID";
				public const string PurposeID="PurposeID";
				public const string VietName="VietName";
				public const string EnglishName="EnglishName";
				public const string JapanName="JapanName";
			}
		}
		#endregion

		#region Supplier
		public class Supplier
		{
			public const string Name = "Supplier";
			public class FieldName
			{
				public const string ID="ID";
				public const string SupplierID="SupplierID";
				public const string SupplierName="SupplierName";
				public const string Note="Note";
			}
		}
		#endregion

		#region Unit
		public class Unit
		{
			public const string Name = "Unit";
			public class FieldName
			{
				public const string ID="ID";
				public const string UnitID="UnitID";
				public const string UnitName="UnitName";
			}
		}
		#endregion

	}
	#endregion

    #region Stored Procedure
    public class StoreProcedure
    {

        public class FieldName
        {

        }

        #region Basic items
        public class Product
        {
            public const string GetAll = "Sp_243_Product_GetAll";
            public const string GetOne = "Sp_243_Product_GetOne";
            public const string Insert = "Sp_243_Product_Insert";
            public const string Update = "Sp_243_Product_Update";
            public const string Delete = "Sp_243_Product_Delete";
        }

        public class ProductGroup
        {
            public const string GetAll = "Sp_243_ProductGroup_GetAll";
            public const string GetOne = "Sp_243_ProductGroup_GetOne";
            public const string Insert = "Sp_243_ProductGroupy_Insert";
            public const string Update = "Sp_243_ProductGroup_Update";
            public const string Delete = "Sp_243_ProductGroup_Delete";
        }

        public class Currency
        {
            public const string GetAll = "Sp_243_Currency_GetAll";
            public const string GetOne = "Sp_243_Currency_GetOne";
            public const string Insert = "Sp_243_Currency_Insert";
            public const string Update = "Sp_243_Currency_Update";
            public const string Delete = "Sp_243_Currency_Delete";
        }

        public class Kind
        {
            public const string GetAll = "Sp_243_Kind_GetAll";
            public const string GetOne = "Sp_243_Kind_GetOne";
            public const string Insert = "Sp_243_Kind_Insert";
            public const string Update = "Sp_243_Kind_Update";
            public const string Delete = "Sp_243_Kind_Delete";
        }

        public class Unit
        {
            public const string GetAll = "Sp_243_Unit_GetAll";
            public const string GetOne = "Sp_243_Unit_GetOne";
            public const string Insert = "Sp_243_Unit_Insert";
            public const string Update = "Sp_243_Unit_Update";
            public const string Delete = "Sp_243_Unit_Delete";
        }

        public class PGroup
        {
            public const string GetAll = "Sp_243_PGroup_GetAll";
            public const string GetOne = "Sp_243_PGroup_GetOne";
            public const string Insert = "Sp_243_PGroup_Insert";
            public const string Update = "Sp_243_PGroup_Update";
            public const string Delete = "Sp_243_PGroup_Delete";
        }

        public class Purchaser
        {
            public const string GetAll = "Sp_243_Purchaser_GetAll";
            public const string GetOne = "Sp_243_Purchaser_GetOne";
            public const string Insert = "Sp_243_Purchaser_Insert";
            public const string Update = "Sp_243_Purchaser_Update";
            public const string Delete = "Sp_243_Purchaser_Delete";
        }

        public class Order
        {
            public const string GetAll = "Sp_243_Order_GetAll";
            public const string GetOne = "Sp_243_Order_GetOne";
            public const string Insert = "Sp_243_Order_Insert";
            public const string Update = "Sp_243_Order_Update";
            public const string Delete = "Sp_243_Order_Delete";
        }

        public class Purpose
        {
            public const string GetAll = "Sp_243_Purpose_GetAll";
            public const string GetOne = "Sp_243_Purpose_GetOne";
            public const string Insert = "Sp_243_Purpose_Insert";
            public const string Update = "Sp_243_Purpose_Update";
            public const string Delete = "Sp_243_Purpose_Delete";
        }

        public class OrderInput
        {
            public const string GetAll = "Sp_243_OrderInput_GetAll";
            public const string GetOne = "Sp_243_OrderInput_GetOne";
            public const string Insert = "Sp_243_OrderInput_Insert";
            public const string Update = "Sp_243_OrderInput_Update";
            public const string Delete = "Sp_243_OrderInput_Delete";
        }

        public class OrderDelivery
        {
            public const string GetAll = "Sp_243_OrderDelivery_GetAll";
            public const string GetOne = "Sp_243_OrderDelivery_GetOne";
            public const string Insert = "Sp_243_OrderDelivery_Insert";
            public const string Update = "Sp_243_OrderDelivery_Update";
            public const string Delete = "Sp_243_OrderDelivery_Delete";
        }
        
        public class Supplier
        {
            public const string GetAll = "Sp_243_Supplier_GetAll";
            public const string GetOne = "Sp_243_Supplier_GetOne";
            public const string Insert = "Sp_243_Supplier_Insert";
            public const string Update = "Sp_243_Supplier_Update";
            public const string Delete = "Sp_243_Supplier_Delete";
        }

        public class Maker
        {
            public const string GetAll = "Sp_243_Maker_GetAll";
            public const string GetOne = "Sp_243_Maker_GetOne";
            public const string Insert = "Sp_243_Maker_Insert";
            public const string Update = "Sp_243_Maker_Update";
            public const string Delete = "Sp_243_Maker_Delete";
        }

        #endregion

        public class Report
        {
            public const string FImportDetails = "Sp_243_Rpt_FImportDetails";
        }

    }
    #endregion

    #region Form Title
    public class Form
    {
        public class MessageBox
        {
            public const string Error = "Error";
            public const string Warning = "Warning";
            public const string Notice = "Notice";
            public const string Message = "Message";
            public const string Confirmation = "Confirmation";
        }

        public class BasicList
        {
            public const string Name = "Basic List";

        }

    }
    #endregion

    #region Form Message
    public class Message
    {
        public const string AddSuccess = "Data added Successfully";
        public const string AddSuccessAndQuestion = "Data added succesfully. Do you want to continue adding data?";
        public const string UpdateSuccessAndQuestion = "Data updated succesfully. Do you want to update again?";
        public const string AddFailed = "An error occurred while inserting the record to database. Please try again.";
        public const string UpdateSuccess = "Update Successfully";
        public const string UpdateFailed = "An error occurred while updating the record to database. Please try again.";
        public const string DeleteQuestion = "Do you want to permanently delete this item(s)?";
        public const string DeleteFailed = "Error occurred when deleting data. Please try again.";
        public const string FormAlreadyOpened = "This form is already opened.";
        public const string TableIsNull = "No data to edit/delete.";
        public const string QuestionUpdateTool = "Are you sure you want to replace the data from {0} into {1}?";
        public const string NoDataToExport = "No data to export.";
        public const string ErrorToExport = "cannot export.";
        public const string ImportSuccessfully = "Import {0} row(s) successfully. Do you want to refresh data now?";
        public const string ImportSuccessfullyLog = "Table [333_Import]: Import {0} row(s) successfully.";
        public const string ImportFailedLog = "Table [333_Import]: Import data failed.\n Message: {0}";
        public const string QuestionOpenFileExport = "Do you want to open the file?";

        public class Frequency
        {
            public const string FrequencyIDCantEmpty = "\"Frequency ID\" cannot be empty.";
            public const string FrequencyNameCantEmpty = "\"Frequency Name\" cannot be empty.";
            public const string FrequencyHasExisted = "This \"Frequency ID\" has existed.";
        }
        public class Borrow
        {
            public const string DateCantEmpty = "\"Date\" cannot be empty.";
            public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
            public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
            public const string StaffCantEmpty = "Please select \"Staff\".";
            public const string MachineCantEmpty = "Please select \"Machine\".";
            public const string MachineNotBorrow = "Machine {0} have not borrowed tool {1}.";
            public const string MachineBorrow = "Machine {0} have borrowed tool {1}!. \nQuantity: {2}";
            public const string WrongQuantity = "There are (is) only {1} tool(s) {0} in the warehouse at this time. \nSo you cannot borrow {2} tool(s).";
            public const string WrongQuantity2 = "There are (is) {1} tool(s) {0} in the warehouse.\nSo you adjust the quantity to {2} is inappropriate.\nPlease check this again.";
            public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
            public const string ToolOutStock = "There is no this tool in the warehouse at this time.";
            public const string ToolInStock = "There are (is) {1} tool(s) {0} in the warehouse at this time.";
        }
        public class Broken
        {
            public const string DateCantEmpty = "\"Date\" cannot be empty.";
            public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
            public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
            public const string MistakeCantEmpty = "Please select \"Mistake\".";
            public const string MachineCantEmpty = "Please select \"Machine\".";
            public const string StatusCantEmpty = "Please select \"Status\".";
            public const string LossNoCantEmpty = "\"Loss No.\" cannot be empty.";
            public const string PartCantEmpty = "Please select \"Part\".";
            public const string ProcessStatusCantEmpty = "Please select \"Process Status\".";
            public const string RotateCantEmpty = "Please select \"Rotate\".";
            public const string StandardSpeedCantEmpty = "\"Standard Speed\" cannot be empty.";
            public const string RealitySpeedCantEmpty = "\"Reality Speed\" cannot be empty.";
            public const string ToKindCantEmpty = "Please select \"To Kind\".";
            public const string MachineNotBorrow = "Machine {0} have not borrowed tool {1}. \nSo this tool cannot be broken on this machine.";
            public const string MachineBorrow = "Machine {0} has borrowed tool {1}. \nQuantity: {2}.";
            public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
            public const string WrongQuantity = "You should decrease the quantity of tool {0} to {1}.\nSo the quantity of broken tool cannot be {2}.";
            public const string WrongQuantity2 = "The old quantity of broken tool: {0}.\nThe new quantity of broken tool which you entered: {1}.\nBut the quantity of {2} tool which machine {3} borrowed are (is): {4}.\nPlease check this again.";


        }
        public class Import
        {
            public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
            public const string DateCantEmpty = "Please select \"Date\".";
            public const string PriceCantEmpty = "\"Price\" cannot be empty.";
            public const string MakerCantEmpty = "Please select \"Maker\".";
            public const string SupplierCantEmpty = "Please select \"Supplier\".";
            public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
            public const string QuantityMustGreaterZero = "Quantity must be greater than 0.";
            public const string PriceMustGreaterZero = "Price (JPY) must be greater than 0.";

        }
        public class JustNew
        {
            public const string DateCantEmpty = "\"Date\" cannot be empty.";
            public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
            public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
            public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
            public const string WrongQuantity = "There are (is) {1} tools {0} in the import warehouse.\nSo you enter the quantity of used tool {2} is greater than the quantity of imported tool.";
            public const string WrongQuantity2 = "There are (is) {1} tools {0} in the import warehouse. \nSo you adjust the quantity of used tool to {2} is inappropriate. Please check this again.";
            public const string ImportQuantity = "There are (is) {1} tools {0} in the import warehouse.";

        }
        public class Kind
        {
            public const string KindIDCantEmpty = "\"Kind ID\" cannot be empty.";
            public const string KindNameCantEmpty = "\"Kind Name\" cannot be empty.";
            public const string KindHasExisted = "This \"Kind ID\" has existed.";
        }
        public class Mistake
        {
            public const string MistakeIDCantEmpty = "\"Mistake ID\" cannot be empty.";
            public const string MistakeNameCantEmpty = "\"Mistake Name\" cannot be empty.";
            public const string MistakeHasExisted = "This \"Mistake ID\" has existed.";
        }
        public class ProcessStatus
        {
            public const string ProcessStatusIDCantEmpty = "\"Process Status\" ID cannot be empty.";
            public const string ProcessStatusNameCantEmpty = "\"Process Status Name\" cannot be empty.";
            public const string ProcessStatusHasExisted = "This \"Process Status ID\" has existed.";
        }
        public class QTool
        {
            public const string ToolIDCantEmpty = "\"QTool ID\" cannot be empty.";
            public const string ToolNameCantEmpty = "\"QTool Name\" cannot be empty.";
            public const string ToolHasExisted = "This \"QTool ID\" has existed.";
            public const string MakerToolNameCantEmpty = "\"Maker's Tool Name\" cannot be empty.";
            public const string RRIToolNameCantEmpty = "\"RRI's Tool Name\" cannot be empty.";
            public const string PriceCantEmpty = "\"Price\" cannot be empty.";
            public const string SafeQtyCantEmpty = "\"Safe Quantity\" cannot be empty.";
        }
        public class Return
        {
            public const string DateCantEmpty = "\"Date\" cannot be empty.";
            public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
            public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
            public const string StaffCantEmpty = "Please select \"Staff\".";
            public const string MachineCantEmpty = "Please select \"Machine\".";
            public const string StatusCantEmpty = "Please select \"Status\".";
            public const string MachineNotBorrow = "Machine {0} has not borrowed tool {1}.\nPlease check this again. The machine which not borrow the tool it will never return that tool.";
            public const string MachineBorrow = "Machine {0} has borrowed {1} tools {2}.";
            public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
            public const string WrongQuantity = "The quantity of returned tool: {0}. \nThe quantity of borrowed tool: {1}. \nSo the quantity of returned tool cannot be greater than the quantity of borrowed. Please check this again.";
            public const string WrongQuantity2 = "The quantity of borrowed tool on machine: {1}. \nThe old quantity of returned tool: {0}. \nBut the new quantity which you entered: {2} is inappropriate.\nPlease check this again.";
            public const string ResultQuantity = "Machine {0} has borrowed {1} tool(s) {2}.\nThis machine return {3} tool(s) today. \nSo the quantity of borrowed tool on this machine: {4}";

        }
        public class Rotate
        {
            public const string RotateIDCantEmpty = "\"Rotate ID\" cannot be empty.";
            public const string RotateNameCantEmpty = "\"Rotate English Name\" cannot be empty.";
            public const string RotateHasExisted = "This \"Rotate ID\" has existed.";
        }
        public class Tool
        {
            public const string ToolIDCantEmpty = "\"Tool ID\" cannot be empty.";
            public const string ToolNameCantEmpty = "\"Tool Name\" cannot be empty.";
            public const string ToolHasExisted = "This \"Tool ID\" has existed.";
            public const string MakerToolNameCantEmpty = "\"Maker's Tool Name\" cannot be empty.";
            public const string PriceCantEmpty = "\"Price\" cannot be empty.";
            public const string PriceMustGreaterZero = "\"Price\" must be greater than 0.";
            public const string SafeQtyCantEmpty = "\"Safe Quantity\" cannot be empty.";
            public const string SafeQtyMustGreaterZero = "\"Safe Quantity\" must be greater than 0.";
            public const string MakerCantEmpty = "Please select \"Maker\".";
            public const string FrequencyCantEmpty = "Please select \"Frequency\".";
            public const string ToolGroupCantEmpty = "Please select \"Tool Group\".";
        }
        public class ToolGroup
        {
            public const string ToolGroupIDCantEmpty = "\"Tool Group ID\" cannot be empty.";
            public const string ToolGroupNameCantEmpty = "\"Tool Group Name\" cannot be empty.";
            public const string ToolGroupHasExisted = "This \"Tool Group ID\" has existed.";
        }
        public class ToolStatus
        {
            public const string ToolStatusIDCantEmpty = "\"Tool Status ID\" cannot be empty.";
            public const string ToolStatusNameCantEmpty = "\"Tool Status Name\" cannot be empty.";
            public const string ToolStatusHasExisted = "This \"Tool Status ID\" has existed.";
        }

        public class ExchangeRate
        {
            public const string CurrentcyCantEmpty = "\"Currency\" cannot be empty.";
            public const string ExchangeRateCantEmpty = "\"Rate\" cannot be empty.";
            public const string ExchangeDateCantEmpty = "\"Exchange Date\" cannot be empty.";
        }

        public class Supplier
        {
            public const string SupplierIdCantEmpty = "\"Supplier ID\" cannot be empty.";
            public const string SupplierNameCantEmpty = "\"Supplier Name\" cannot be empty.";
            public const string SupplierCompanyCantEmpty = "\"Company\" cannot be empty.";
            public const string SupplierAddressCantEmpty = "\"Address\" cannot be empty.";
            public const string SupplierCountryIdCantEmpty = "\"Country\" cannot be empty.";
            public const string SupplierTelephoneCantEmpty = "\"Telephone\" cannot be empty.";
            public const string SupplierFaxCantEmpty = "\"Fax\" cannot be empty.";
            public const string SupplierCommodityCantEmpty = "\"Commodity\" cannot be empty.";
            public const string SupplierHasExisted = "This \"Supplier ID\" has existed.";
        }

        public class Maker
        {
            public const string MakerIDCantEmpty = "\"Maker ID\" cannot be empty.";
            public const string MakerNameCantEmpty = "\"Maker Name\" cannot be empty.";
            public const string MakerHasExisted = "This \"Maker ID\" has existed.";
        }

    }
    #endregion

}
}
